﻿    -- DROP FUNCTION "Add_Institution"(VARCHAR);
    CREATE OR REPLACE FUNCTION "Add_Institution" (
        name VARCHAR(128)
    ) 
    RETURNS void 
    AS 
    $$
    /***************************************************************************************************
    **  Function:	public."Add_Institution"
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Add institution into institution table.
    **
    **  Parameters (1):
    **
    **      name    VARCHAR(128)    -
    **
    **  Return:
    **
    **      void
    **
    **  Sample call:
    **
    **      SELECT "Add_Institution"('test_institution'); 
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial prototype
    ** 
    **  Status:
    **
    **      Dev
    ** 
    ***************************************************************************************************/
    BEGIN
        INSERT INTO public."Institution" ("Name") VALUES (name);
    END;
    $$ LANGUAGE plpgsql;